Release 10.1A: OpenEdge Data Management:
DataServer for ORACLE

Preparing a database for the utility

The Progress-to-ORACLE utility does not literally translate definitions for Progress fields into ORACLE columns. It makes some adjustments in order to provide the functionality of the Progress and ORACLE systems. Table 7–4 describes the changes to a database that result from making an OpenEdge database compatible with ORACLE by selecting the Create Progress RECID option when using the Progress-to-ORACLE utility.

Table 7–4: A Progress-to-ORACLE database conversion 

OpenEdge database	ORACLE database
Record ID	An additional NUMBER column named PROGRESS_RECID.
Case-insensitive index	The UPPER(column-name) syntax is used by the index SQL.
Array	A column for each array element named field##1, field##2, etc.
Sequence	A sequence with the same characteristics (incrementation, beginning value, etc.).

The utility makes these changes in the target ORACLE database automatically. The following sections explain how to account for these changes when you plan your migration.